UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KXv37OxLaocHD7b2jjmydiXFkyg+p54zcZLcvWn5xjw='
WHERE
key_id = '537e45e0c006b91a9d2919411789a98dfb4babb0538d0d910815b9e48be876c1'
AND (
token = 'KXv37OxLaocHD7b2jjmydiXFkyg+p54zcZLcvWn5xjw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)