UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Cr2WMl6zowfSw+ch+5pD8xXImpp7uqxy/2+r0cuBow='
WHERE
key_id = '009dc4f70e98ee2ce85ffadab8f4ef440fa768cc9b1b6fffe415fdd19e0facf2'
AND (
token = '0Cr2WMl6zowfSw+ch+5pD8xXImpp7uqxy/2+r0cuBow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)