UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xqHN+Mn0H9HzCH775P87eyPCbwU20gL7zEfq7YCFGu8='
WHERE
key_id = '29f11a0b9c0786098dd9809d408bbb9c36be7ef6ad0c97f8b9a9c9a817deb5f3'
AND (
token = 'xqHN+Mn0H9HzCH775P87eyPCbwU20gL7zEfq7YCFGu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)