UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'c+IgHpt6x+RgFLSqw2/mVBfP5ChjCEwk4vY6bj9StBc=' 
WHERE 
  key_id = '4dbe35ad18fad17effcadbd4b83a15c58456d32e755a4dc9ed1f67c8f1b367a3' 
  AND (
    token = 'c+IgHpt6x+RgFLSqw2/mVBfP5ChjCEwk4vY6bj9StBc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00057