UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FYW8CEQfKAdGrgiG643GGLP7KHg3kreYB8cnX1+TtZs='
WHERE
key_id = '77642bdd1fdf3b24d12216ce444055179e8bbf1c3fc3b30694eb8dccbcabc6df'
AND (
token = 'FYW8CEQfKAdGrgiG643GGLP7KHg3kreYB8cnX1+TtZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)