UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'g1t7Qg1G5joJYYoWGER3d4+rDCgXAZ0y/J0Wxj3P5HA=' 
WHERE 
  key_id = 'e955a423ea215f5c756b0c87aee185ea0a7ba900514991c6ff369495286f9a2f' 
  AND (
    token = 'g1t7Qg1G5joJYYoWGER3d4+rDCgXAZ0y/J0Wxj3P5HA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029