UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wTSg8URcX3y5yCrLErAGsYfvMsqa1V+HElBDruHv2hs='
WHERE
key_id = 'cd0cb2c06c0c626d2bb7489483cfc5642f7d7de9eada763a2aa1959e88abcb77'
AND (
token = 'wTSg8URcX3y5yCrLErAGsYfvMsqa1V+HElBDruHv2hs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)