UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZbEcihn2ycEaBS5lgtrmB1k/7yHXKLTYN+fLI/YukqU=' 
WHERE 
  key_id = '54ca248d157b90a5f095efde0fb8aa4d486a763334127da7b0199e46db137018' 
  AND (
    token = 'ZbEcihn2ycEaBS5lgtrmB1k/7yHXKLTYN+fLI/YukqU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025