UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'iJHwLFq/18jZ86j193/EIF4n5Ir6a/wnqvKIvZJY3+M=' 
WHERE 
  key_id = '3935891814d7b6d77c80bd0e74ef2ce992d58dce632301c94749b6d07700fe29' 
  AND (
    token = 'iJHwLFq/18jZ86j193/EIF4n5Ir6a/wnqvKIvZJY3+M=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021