UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9qVNpZ2shsmXE7K22M22A0ICv9ng24mIf2RIIz3PD9Y='
WHERE
key_id = '29b8bd0989eb2f9e6c3ea5a65c9fcaa28b15300d961af607731b756a51894078'
AND (
token = '9qVNpZ2shsmXE7K22M22A0ICv9ng24mIf2RIIz3PD9Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)