UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MVxKgrw9m9agkZwEdw13jr9NRVCzJAZaZLKR1ompZio=' 
WHERE 
  key_id = '70c6d095926fdee8164a92c20c01cd24d1bdc7fa8b6d1e70fc87f7c9bbe68bd1' 
  AND (
    token = 'MVxKgrw9m9agkZwEdw13jr9NRVCzJAZaZLKR1ompZio=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020