UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9b/w1msqYyp+pzJGJH1FW2LXPIKOWXoymg+06yIVzaM='
WHERE
key_id = 'c9be91a90ca39867b0f26d89ab47d980e45ab05dd017c8bc691e4016f66d6374'
AND (
token = '9b/w1msqYyp+pzJGJH1FW2LXPIKOWXoymg+06yIVzaM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)