UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P/ZWeJ5PHyz/DrYn0Lj2JxlBaVcEARNZMxp7IOT/oLk='
WHERE
key_id = '797c8dfeed771e199605778db28191efa8b0056d10a2847608dbbde1e6c31b1d'
AND (
token = 'P/ZWeJ5PHyz/DrYn0Lj2JxlBaVcEARNZMxp7IOT/oLk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)