UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HMrkCXRG7geOAVRBXKf5RckVIcLGqdbYyidtqTmz6og='
WHERE
key_id = '13945ff8cf133e8de411f427a9af64a531fd4de0c21868884047fc5334717cf9'
AND (
token = 'HMrkCXRG7geOAVRBXKf5RckVIcLGqdbYyidtqTmz6og='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)