UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FqPF/e1oP40nkSX1vkoximCbSTcLEaWVYQIWQzyT1bw='
WHERE
key_id = '9cf63587a615d8726fb1758608d8b44efa5fb24584562f3692ec3c1cb2f8c141'
AND (
token = 'FqPF/e1oP40nkSX1vkoximCbSTcLEaWVYQIWQzyT1bw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)