UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'm3BOcXkjE5qH650b0cXlQrLd8GEOlOSx9JJ9AotT2tA=' 
WHERE 
  key_id = '07ecddb314997e338f1dceb5b2ede6f8c08c422cec6d505e809826ebd13ddcd6' 
  AND (
    token = 'm3BOcXkjE5qH650b0cXlQrLd8GEOlOSx9JJ9AotT2tA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025