UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'sUYDeL0ZO9OT9A0M/y1dMHbKMY3OF1YmcO/z7ZDxTNs=' 
WHERE 
  key_id = '84bee3d85ec126de5831cabd99421290a2fcbd17a32f32754a5c99b5f455197f' 
  AND (
    token = 'sUYDeL0ZO9OT9A0M/y1dMHbKMY3OF1YmcO/z7ZDxTNs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020