UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NFcMfQ7Ni1DCdTZh5yikfr9EAgTDxeEJ1wf3RH76Img=' 
WHERE 
  key_id = 'a09f9e2ca3fcb53d80bda5dc002db4b16601a381bf7a66413e7e14e277b5ce21' 
  AND (
    token = 'NFcMfQ7Ni1DCdTZh5yikfr9EAgTDxeEJ1wf3RH76Img=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033