UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2kpxyY8VmBBy6M7mJXmgZT27Hg5w9Hypj94KkMcQdjc=' 
WHERE 
  key_id = '970ffe7ef7e35fb96f170f4f6e8be7e7013a9f9790d6d9c0bf89a9610bac6ecc' 
  AND (
    token = '2kpxyY8VmBBy6M7mJXmgZT27Hg5w9Hypj94KkMcQdjc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030