UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'uXT7aaKh7R3UmIMaUIrvL0p15a1EEXhKeJoI8wQsZkg=' 
WHERE 
  key_id = '3aa871a772595dad13f8c2ae4cecbf395ad0f20c1071f5aa1d1a09e7acdbba27' 
  AND (
    token = 'uXT7aaKh7R3UmIMaUIrvL0p15a1EEXhKeJoI8wQsZkg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020