UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7g6IQNRilDUmcHeJEEx4mSP4YwFkUJ5Yqz36FaKvTcI='
WHERE
key_id = 'b04d40be92495968bac7ddcbd1715974dc70e847b07ce02c5c896c6cef25422a'
AND (
token = '7g6IQNRilDUmcHeJEEx4mSP4YwFkUJ5Yqz36FaKvTcI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)