UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cZxT4GrahFvvQbRnwk6oMpQDsvARhX8l5/emuzC5Ct8='
WHERE
key_id = 'b8516ddcda517c073e8f96276bf0723e6aa84b05737763a5d11c36b3de1ee426'
AND (
token = 'cZxT4GrahFvvQbRnwk6oMpQDsvARhX8l5/emuzC5Ct8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)