UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'T1NEPGF2gLUtvFig6cvARwMvGQ9N9JbMWuQdyeZucXU=' 
WHERE 
  key_id = '0fd29eda5a3a7060a05f9a473e5c112a18ad3765c8f104777520f2e8f692ebe6' 
  AND (
    token = 'T1NEPGF2gLUtvFig6cvARwMvGQ9N9JbMWuQdyeZucXU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00051