UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qKEQTMludC+Lo8/pZ5BIKLf0rkCoYzBZY4yGVwjszsE=' 
WHERE 
  key_id = '7c919337aaa299c888a39773b96b0590c712b0ebc1c6b81684765b1cd0aec724' 
  AND (
    token = 'qKEQTMludC+Lo8/pZ5BIKLf0rkCoYzBZY4yGVwjszsE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021