UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5PImeXQkY0PsOO9ksfYASFSuAnMKYaL1kn4a5NuKzRI=' 
WHERE 
  key_id = '87746e7761884187beb3d5a080b950b9f5685d5f2410fa4a72ae9706c7100607' 
  AND (
    token = '5PImeXQkY0PsOO9ksfYASFSuAnMKYaL1kn4a5NuKzRI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024