UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vL1g0n5lP8KLHmrC7ONRgvNFjCa2c7uDppFMUZQdnr8='
WHERE
key_id = '224fe6fcf72999a253b8d36192b25fabecc9dffec69e1a764698b88c504f5981'
AND (
token = 'vL1g0n5lP8KLHmrC7ONRgvNFjCa2c7uDppFMUZQdnr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)