UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'LVCpKW6RBDr8v1B9pZwHgIcqCuZJtzSYZsIZ/nCeVtI=' 
WHERE 
  key_id = '6ad9b67e961d1362eb715375be5b51a156197fc8d1b5be4feb7e20adb4910ba8' 
  AND (
    token = 'LVCpKW6RBDr8v1B9pZwHgIcqCuZJtzSYZsIZ/nCeVtI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00011