UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2ZScfpf8VJxJwttFWdMewAZiiWE5NOkyVoURq4Iz63A='
WHERE
key_id = 'ca28a22220edeaf43bce18f197f1f80dffe3093610253e29f103d5822f77cff7'
AND (
token = '2ZScfpf8VJxJwttFWdMewAZiiWE5NOkyVoURq4Iz63A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)