UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'plA0R2MQ8IwYna8S6RqKpktZ7+jtkTM7Zl+G17fbQTg='
WHERE
key_id = '3544bea348880eba82ae64a833dccd978173d67c0cd8a1b49e60df087ec24b2e'
AND (
token = 'plA0R2MQ8IwYna8S6RqKpktZ7+jtkTM7Zl+G17fbQTg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)