UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zBnMRDYPOfnucA+R5VVM9A0cfyJcAE3nVaw+AcXCAD0='
WHERE
key_id = '1d1b468e0040c0884d32f68cca78a778ccf70e08ca5dd58f24a7f259cd20a803'
AND (
token = 'zBnMRDYPOfnucA+R5VVM9A0cfyJcAE3nVaw+AcXCAD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)