UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'g+RhoBsH9iIobTAOf3aJCQuo2z+C3KOflhujEQDVRRU=' 
WHERE 
  key_id = 'a3f03d5e26f9288ffc36c157e07ff729b6dd733379a2416e15fceb8489e56d15' 
  AND (
    token = 'g+RhoBsH9iIobTAOf3aJCQuo2z+C3KOflhujEQDVRRU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025