UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dYyJZsUvoVHRU69i2wOzzOy545KWEetn6P20IZH7Xic='
WHERE
key_id = '588f451c689efe9805e891fc21833d81a7380d3d2082d3e5b76512ed35393d6e'
AND (
token = 'dYyJZsUvoVHRU69i2wOzzOy545KWEetn6P20IZH7Xic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)