UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JgQs0vHbeXUlK6QfCMZp2vgwGW/nmaTAgAdYUnB/eCI='
WHERE
key_id = '2644c2dddc32daef8dd1f451d712f69230dcc37cd96dde6df6ea13348d860b33'
AND (
token = 'JgQs0vHbeXUlK6QfCMZp2vgwGW/nmaTAgAdYUnB/eCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)