UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'htnYw4Ygq7eAsyydlUUGkFRbjpGdaoJgihKWchS3XuA='
WHERE
key_id = '57a992f09c0a1c77c62cd240934e7863a50d2b05fdf4bbfb429f1813335fa9be'
AND (
token = 'htnYw4Ygq7eAsyydlUUGkFRbjpGdaoJgihKWchS3XuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)