UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '456sBgRNQOfWlSgIR+hMhhmw3A4eXR5/7Bb+mAAq5Sg='
WHERE
key_id = '7e1164777c3be39c9f4a3693b64e486862cdd47d00ca43dfd40d76c7bd3080c0'
AND (
token = '456sBgRNQOfWlSgIR+hMhhmw3A4eXR5/7Bb+mAAq5Sg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)