UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'brv2Bk9pyRx3RNABYk4VEgXpmulBRU7SdYRHozxbUGw=' 
WHERE 
  key_id = '423b4e2a86f75e9cf977cafaf5d132bfaf8ffa6bd22b03377b8e557c81d9c746' 
  AND (
    token = 'brv2Bk9pyRx3RNABYk4VEgXpmulBRU7SdYRHozxbUGw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046