UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XXSGSQxCXCb8lu8wgJBo+4HbJCy8T2o3czt9AFuwtkc=' 
WHERE 
  key_id = '9728b5458b2d3650435034331a4438dd8dd76db79189b812c767029323ee6fe0' 
  AND (
    token = 'XXSGSQxCXCb8lu8wgJBo+4HbJCy8T2o3czt9AFuwtkc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045