UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pPTfgQciG6sINNhR3OvsAVh7ylx4Egh8tFP6bqY6oiM='
WHERE
key_id = '226bba1e0c15b90920526a1acad5d125f9fea84764ec90cfbc3d6e4de8d15451'
AND (
token = 'pPTfgQciG6sINNhR3OvsAVh7ylx4Egh8tFP6bqY6oiM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)