UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HapP/y7WOdnbIlpVhgz+LqxMzMI6cm42L7g1qyH5hNs='
WHERE
key_id = 'a7571bbde38ff1a1a1068ddc2844e75b8c7414e044dc8fdfeff6fbfe8058e7cb'
AND (
token = 'HapP/y7WOdnbIlpVhgz+LqxMzMI6cm42L7g1qyH5hNs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)