UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gr8t7zMlJ/zBlDpeBXHY6FqKSZiHwOS61a/QmJINZTY='
WHERE
key_id = '5978f49742c9ffe8fd3f6bff2893fffe4993383dc22f68a0dbae373f6d1ed3ec'
AND (
token = 'Gr8t7zMlJ/zBlDpeBXHY6FqKSZiHwOS61a/QmJINZTY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)