UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y04bW5rhNyMRuez9uGFku8xiZAqkZKuEdYS2IUgZqfk='
WHERE
key_id = '8f817e2d6d7701e22216c67c78d0bec4b0f04733771aa930598c86377a0f138c'
AND (
token = 'y04bW5rhNyMRuez9uGFku8xiZAqkZKuEdYS2IUgZqfk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)