UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vZm1M+qyni0nUm2oosUgpHmbIWNpJrjzNmfdge6d+FE='
WHERE
key_id = '697d8b51fe8697d6ae50e891594b174ec75b630b2409215e039c4734dbaa5773'
AND (
token = 'vZm1M+qyni0nUm2oosUgpHmbIWNpJrjzNmfdge6d+FE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)