UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9V9y9Ipw6OeSY+/MvGouRuVLACyFcgWOgtaDukknY7k='
WHERE
key_id = 'd0e737628bb3b8904fde778a0fe112b9056e488cff09f78883bbaac75a88779c'
AND (
token = '9V9y9Ipw6OeSY+/MvGouRuVLACyFcgWOgtaDukknY7k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)