UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '93A9HKtzE02bdt3BHihWEWJx1XdNgL7FAa313DI3Euw='
WHERE
key_id = '50d3d83d73653eed3c5b1bee325314bd37e4e7e9b6d4f3b165866f0fb9aeec47'
AND (
token = '93A9HKtzE02bdt3BHihWEWJx1XdNgL7FAa313DI3Euw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)