UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'nZXX1VxGFIEdzdX3j3dQiMfXLEqqRckZZ9YrQfugxQE=' 
WHERE 
  key_id = '9efb3e7e89f58ad1caa611f7497f5cd4d804802e5c5698fe1533a1cb36faa301' 
  AND (
    token = 'nZXX1VxGFIEdzdX3j3dQiMfXLEqqRckZZ9YrQfugxQE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026