UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9oX6ytlfiWmGnPBsIWTanSRkGjRBFEhpDXdxeYRFuak='
WHERE
key_id = 'b7916ab5277e878902b760cd158c5d074fa87b5d8c2b85380c8429c4bc71f57e'
AND (
token = '9oX6ytlfiWmGnPBsIWTanSRkGjRBFEhpDXdxeYRFuak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)