UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9hFJvmRqMW6bxJLUiPad5ZAYf2HwBy1OqFEu8+88wUc='
WHERE
key_id = '734ea6b19d6e7db6abbf2ea97e2b5459def16340332c6f2db6f21e423a930fa0'
AND (
token = '9hFJvmRqMW6bxJLUiPad5ZAYf2HwBy1OqFEu8+88wUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)