UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0zGbN/ymw75NSTeiX62KL7ZFz9q1dBSneCo24KXqFyI=' 
WHERE 
  key_id = '87e210f55e2a5dacd439c958f62a50f36cfe42068751dcd4679529f07160018f' 
  AND (
    token = '0zGbN/ymw75NSTeiX62KL7ZFz9q1dBSneCo24KXqFyI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046