UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ynyw3XB914QSczWjfHBHOYbkZc5d2lpu9UUauclkFmU=' 
WHERE 
  key_id = 'c98c0c444a28a2c1a57c8d7caf3b68907234a11b8cd5c5a59bd56e65e969d604' 
  AND (
    token = 'ynyw3XB914QSczWjfHBHOYbkZc5d2lpu9UUauclkFmU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047