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())
)