UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aZL7xWZpKcC5RvlwfGjYO4ztA4eVKGnkDUG26h86Vnw='
WHERE
key_id = '5ae44b249780552e8a26c5c061e17309ab3cd38c79d62a310637b6d356067ccc'
AND (
token = 'aZL7xWZpKcC5RvlwfGjYO4ztA4eVKGnkDUG26h86Vnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)