UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dg1eol1+Vz37dglRV5R/hp1RZgjfAOGKv8wkOQZnC0Q='
WHERE
key_id = '158a73e39fae16b36f478d72b4b5541acf5e26c1b91f5e70575ce54ac9a8a873'
AND (
token = 'Dg1eol1+Vz37dglRV5R/hp1RZgjfAOGKv8wkOQZnC0Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)