UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+ZWdSe25HuubnsKFECg+zyTaIGcKW2CA0gTvWlmDWuM='
WHERE
key_id = '3f63b76a7ee5740fb7ee4bef7ef9c37bf78826e5d94c361ac05fc0dd1726858c'
AND (
token = '+ZWdSe25HuubnsKFECg+zyTaIGcKW2CA0gTvWlmDWuM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)