UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lN8VPNcffFLzGuUGgW6ay3A81Wpm0y83/KB11iXGIqc='
WHERE
key_id = '9d33caa61dddf70d5e8eefe912090ba27f0c40988015b519e7eecec344b7c780'
AND (
token = 'lN8VPNcffFLzGuUGgW6ay3A81Wpm0y83/KB11iXGIqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)