UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'gooxQtUI0BSyY9sBFe9M0y/VFOtDo1hzJvZZcu4ErEA=' 
WHERE 
  key_id = 'de0a1921ab67bd5b0675dc222ed8c3cbaa5fb5a5e1fc947a413ec8398ea74917' 
  AND (
    token = 'gooxQtUI0BSyY9sBFe9M0y/VFOtDo1hzJvZZcu4ErEA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021