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

Query time 0.00023