UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vcz5Dy/4/un4S30nb34dGsF7ijrjCjau27e7zxmvxEk='
WHERE
key_id = '5e7666b69d75bdd84efd1e37042cb1a01e9118a3258577384f0fcb5f977f77ab'
AND (
token = 'vcz5Dy/4/un4S30nb34dGsF7ijrjCjau27e7zxmvxEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)