UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XsGeAC77jieL+kc11HPUywqGztXd35gZzMKKAEtRqys='
WHERE
key_id = '5176b9b759d9710ce868754f8bfd9e1e80ddf205126ccec20ea2cbe52ea687d3'
AND (
token = 'XsGeAC77jieL+kc11HPUywqGztXd35gZzMKKAEtRqys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)