UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kEsdcKwmWlw+bBFHNxYgK8NHoC2yO+vY+HJWVjag1yM='
WHERE
key_id = '7cb83daa2e63a4a19a1ed1067942c9c812948d90046a03ed0843b5096cdd5ed0'
AND (
token = 'kEsdcKwmWlw+bBFHNxYgK8NHoC2yO+vY+HJWVjag1yM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)