UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'SLEDvVTBCdHA36O6ZCtEBi2fYdlC78qTc7Oz7Jlwyi8=' 
WHERE 
  key_id = '1a7ff4ba27a7298644c1a77e4b7f66b4eba91fa203db75c5b592b325c1152f6f' 
  AND (
    token = 'SLEDvVTBCdHA36O6ZCtEBi2fYdlC78qTc7Oz7Jlwyi8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022