UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RsHgK5ZFpGhv6A0aEulo/VPwkOiTNYTWEz40rJTopMw='
WHERE
key_id = '0f5a171a4a77cca321f3ebf0b28df5a8819eca115b65f4a7bfa537011141c6aa'
AND (
token = 'RsHgK5ZFpGhv6A0aEulo/VPwkOiTNYTWEz40rJTopMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)