UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'A09R9WKZww2EXBU8NR3XW1Tzbo8ZuFMTuxyrtO4MJR0=' 
WHERE 
  key_id = '2654dadb7fb533e763c16b1d66c270c57ef41d76c395a8a8066bd9af678da4b9' 
  AND (
    token = 'A09R9WKZww2EXBU8NR3XW1Tzbo8ZuFMTuxyrtO4MJR0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020